select trim(GOODPRICES.SEQNO) as SEQNO,trim(GOODPRICES.MATNR) as MATNR,trim(GOODPRICES.MAKTX_C) as MAKTX_C,trim(GOODPRICES.WERKS) as WERKS,trim(GOODPRICES.NETPR) as NETPR,trim(GOODPRICES.MEINS) as MEINS,trim(GOODPRICES.UMREZ) as UMREZ,trim(GOODPRICES.GROES) as GROES,
formmain_0177.ID from GOODPRICES
left outer join formmain_0177 on trim(GOODPRICES.SEQNO)=trim(formmain_0177.field0006) 
where formmain_0177.ID is null